<?php 
/*
 * Session variables:
 * $_SESSION['database'] [string] = database name of the current tutorial centre
 * $_SESSION['type'] [string] = user type of the logged in user
 * $_SESSION['authorised'] [boolean] = whether or not the current user is logged in
 * $_SESSION['user'] [string] = the username/ email of the logged in user 
 */
session_start();

if(isset($_SESSION['authorised']) && $_SESSION['authorised'] == true)
{
	if(isset($_SESSION['type']))
	{
		if($_SESSION['type'] == 'administrator')
		{
			header('Location: admin_index.php');
			exit();
		}
		elseif($_SESSION['type'] == 'student')
		{
			include('connection.inc');
			?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>View Transactions</title>
<link href="StyleSheet.css" rel="stylesheet" type="text/css" />
<style>
.nav {
	width: 210px;
	height: auto;
	border: thin solid #09C;
	margin-left: 10px;
	text-align: center;
}

.mainline {
	width: 712px;
	height: auto;
	text-align: center;
}
</style>
</head>
<body bgcolor="#FFFFFF">
	<center>

		<div id="wrapper">
			<div id="header">
				<h1></h1>
			</div>

			<div id="header2">
				<h3></h3>
			</div>

			<div id="nav">
				<?php include 'student_navigation.php';?>
			</div>

			<div id="mainline">
				<h4>View Transactions</h4>
				<div id="body">
					<table width="700" height="auto" cellpadding="3" cellspacing="1" align="center">
						<tr height="40" bgcolor="LightSteelBlue"><th>Paid Transactions</th></tr>
					</table>
					<table width="700" height="auto" cellpadding="3" cellspacing="1" align="center">
        			<tr height="40" bgcolor="LightSteelBlue">
							<th>Transaction ID</th>
							<th>Date</th>
							<th>Amount</th>
							<th>Description</th>
						</tr>
						<?php 
							$username = $_SESSION['user'];
							$sql = "SELECT student_id, payment FROM students where username = '$username'";
							$result = pg_query($sql);
							$student_id = pg_fetch_result($result, 0, 'student_id');
							$payment = pg_fetch_result($result, 0, 'payment');
							$sql = "SELECT * FROM transactions where username = '$username' ORDER BY transaction_date ASC";
							$result = pg_query($sql);
							$count = pg_num_rows($result);
					            if($count<1)
					            {
					            	echo "</table>";
					            	echo "<br>No transactions<br /><br /><br />";
					            }
							else
							{
					            for ($i = 0; $i < pg_num_rows($result); $i ++) 
					            {
									$transaction_id = pg_fetch_result($result, $i, 'transaction_id');
									$timestamp = pg_fetch_result($result, $i, 'transaction_date');
					                $time = date_create_from_format('Y-m-d G:i:s.u', $timestamp);
					                $date= date_format($time, 'M-d-Y \a\t g:i a');
									$amount = pg_fetch_result($result, $i, 'amount');
									$description = pg_fetch_result($result, $i, 'description');
									echo '<tr align="center" bgcolor="#f5f5f5">';
									echo "<td>$transaction_id</td>";
									echo "<td>$date</td>";
									echo "<td>PhP $amount</td>";
									echo "<td>$description</td>";
									echo "</tr>";
								}
								echo "<tr height=\"40\" bgcolor=\"LightSteelBlue\"><td colspan=\"3\"><b>Outstanding Balance</b></td><td>$payment</td></tr>";
								echo "</table><br /><br /><br />";
							}
						?>
						
				</div>
			</div>

			<br class="clearfloat"> <br />

			<div id="footer">
				<p align="center">
					Tutorial Business Manager: info@tbms.com <br />Credits/Engineers:
					Aquino, Chloebelle; Dela Cruz, Roy Erwin; Maliwanag, Ranyel Bryan;
					Manzano, Audrey Ann; Ng, Sheila Regine<br /> <br />copyright 2011
				</p>
			</div>
		</div>
	</center>
</body>
</html>
			<?php
		}
		elseif($_SESSION['type'] == 'tutor')
		{
			header('Location: tutor_index.php');
			exit();
		}
		elseif($_SESSION['type'] == 'parent')
		{
			header('Location: parent_index.php');
			exit();
		}
	}
}
else
{
	header('Location: index.php');
}


?>